USE [RD_COMMON]
GO
USE [RD_COMMON]
GO
/****** Object:  Index [IX_AR_Star_BillToNumber]    Script Date: 06/16/2009 09:59:20 ******/
CREATE NONCLUSTERED INDEX [IX_AR_Star_BillToNumber] ON [dbo].[AR_Star_Customer] 
(
	[BillToNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
/****** Object:  Index [IX_AR_Star_Customer_BillTo_Company]    Script Date: 06/16/2009 09:59:20 ******/
CREATE NONCLUSTERED INDEX [IX_AR_Star_Customer_BillTo_Company] ON [dbo].[AR_Star_Customer] 
(
	[BillToNumber] ASC,
	[CompanyNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_AR_Star_Customer_CustomerNumberID]    Script Date: 06/16/2009 09:59:20 ******/
CREATE NONCLUSTERED INDEX [IX_AR_Star_Customer_CustomerNumberID] ON [dbo].[AR_Star_Customer] 
(
	[CustomerNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Index [IX_AR_Star_CustomerNumber]    Script Date: 06/16/2009 09:59:20 ******/
CREATE NONCLUSTERED INDEX [IX_AR_Star_CustomerNumber] ON [dbo].[AR_Star_Customer] 
(
	[CustomerNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
/****** Object:  Index [IX_AR_Star_ParentNumber]    Script Date: 06/16/2009 09:59:20 ******/
CREATE NONCLUSTERED INDEX [IX_AR_Star_ParentNumber] ON [dbo].[AR_Star_Customer] 
(
	[ParentNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]

/****** Object:  Index [PK_Star_Account]    Script Date: 08/20/2010 15:23:49 ******/
ALTER TABLE [dbo].[Star_Account] ADD  CONSTRAINT [PK_Star_Account] PRIMARY KEY CLUSTERED 
(
	[AID] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO


USE [RD_COMMON]
GO

/****** Object:  Index [IX_Account_AIDID]    Script Date: 08/20/2010 15:23:44 ******/
CREATE NONCLUSTERED INDEX [IX_Account_AIDID] ON [dbo].[Star_Account] 
(
	[AIDID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Account_BU]    Script Date: 08/20/2010 15:23:44 ******/
CREATE NONCLUSTERED INDEX [IX_Account_BU] ON [dbo].[Star_Account] 
(
	[Account] ASC,
	[BusinessUnitCode] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_204]    Script Date: 08/20/2010 15:23:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_204] ON [dbo].[Star_Account] 
(
	[Category12Code] ASC
)
INCLUDE ( [AIDID]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_264]    Script Date: 08/20/2010 15:23:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_264] ON [dbo].[Star_Account] 
(
	[Category17Code] ASC
)
INCLUDE ( [Category17],
[Category17Desc2]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_44]    Script Date: 08/20/2010 15:23:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_44] ON [dbo].[Star_Account] 
(
	[Category13Code] ASC
)
INCLUDE ( [AIDID],
[Category13],
[Category14Code],
[Category14]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_53]    Script Date: 08/20/2010 15:23:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_53] ON [dbo].[Star_Account] 
(
	[Category13Code] ASC
)
INCLUDE ( [AIDID],
[Account],
[AccountDesc],
[Category13],
[Category14Code],
[Category14]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_66]    Script Date: 08/20/2010 15:23:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_66] ON [dbo].[Star_Account] 
(
	[Category13Code] ASC
)
INCLUDE ( [AIDID]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_89]    Script Date: 08/20/2010 15:23:44 ******/
CREATE NONCLUSTERED INDEX [missing_index_89] ON [dbo].[Star_Account] 
(
	[Category13Code] ASC
)
INCLUDE ( [AIDID],
[Account],
[AccountDesc],
[AccountLevelOfDetail],
[Category13],
[Category14Code],
[Category14]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO


